import numpy as np
import pandas as pd

df=pd.read_csv("transaction_data.csv")

result=np.where(df['is_refund']==1,df['transaction_amount'],0)
result=np.sum(result)
print(result)
